package com.elite.groovy.dev;

import com.elite.groovy.kh.KHFileUtil;
import com.elite.groovy.kh.KHUtil;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

/**
 * 云片短信模板处理
 */
public class SMS_Template {
    private static final Log log = LogFactory.getLog(SMS_Template.class);

    public static void main(String[] args) throws Exception {

        String inData = "{\n" + "    \"code\": 0,\n" + "    \"msg\": \"ok\",\n" + "    \"data\": {\n" + "        \"records\": [\n" + "            {\n" + "                \"id\": \"5804946\",\n" + "                \"applyTime\": 1699411849000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！为了更好地为您提供服务，请点击以下链接在线填写咨询内容，我们将在1个工作日内安排专属客服为您服务。https://dx5.cn/4ECDlP \",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"提交工单\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                },\n" + "                \"shortUrlInfo\": {\n" + "                    \"sid\": \"4ECDlP\",\n" + "                    \"version\": \"NEW\"\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5804902\",\n" + "                \"applyTime\": 1699409153000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！因人工服务繁忙，十分抱歉未能及时响应。为了更好地为您提供服务，请点击以下链接在线填写咨询内容，我们将在1个工作日内安排工作人员为您服务。https://dx5.cn/4ECDlP \",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"提交工单\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                },\n" + "                \"shortUrlInfo\": {\n" + "                    \"sid\": \"4ECDlP\",\n" + "                    \"version\": \"NEW\"\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5797028\",\n" + "                \"applyTime\": 1698285350000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，您符合换货奖励，请邮寄假货产品到以下地址：美缝剂回收组收，020-8441717，广东省广州市海珠区南洲路158号南塔西卡德高公司。本公司仅支持顺丰快递或京东快递到付，其他快递到付件一律拒收，寄出后请点击 #belong_city# 填写寄件单号和收件信息。如有疑问请拨打4008009889咨询。 \",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"邮寄地址告知\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5759614\",\n" + "                \"applyTime\": 1694499375000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！您可通过以下授权的线上商城购买西卡产品：天猫：西卡旗舰店；京东：西卡官方旗舰店   西卡京东自营旗舰店\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"用户获取店铺类型\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5759616\",\n" + "                \"applyTime\": 1694499401000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！您可通过以下授权的线上商城购买德高产品：天猫：德高旗舰店；京东：德高官方旗舰店、德高(Davco）京东自营旗舰店；拼多多：DAVCO德高旗舰店；抖音：德高官方旗舰店\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"用户获取专卖店类型\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5731250\",\n" + "                \"applyTime\": 1692079764000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，您提交的线索不符合举报填写要求，感谢参与。如有疑问请拨打4008009889咨询。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"假货举报结果反馈\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5729994\",\n" + "                \"applyTime\": 1692079705000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，您提交的线索，已被相关行政/公安机关查处，请耐心等待国家单位的处理结果，感谢参与。如有疑问请拨打4008009889咨询。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"假货举报内容回复\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5729990\",\n" + "                \"applyTime\": 1692065030000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，您提交的线索，已被相关行政机关查处，符合奖励标准，请点击链接：https://dx5.cn/4i65LQ 注册账号，奖励将通过德高好工匠平台进行发放，感谢参与。如有疑问请拨打4008009889咨询。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"假货举报内容回复\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                },\n" + "                \"shortUrlInfo\": {\n" + "                    \"sid\": \"4i65LQ\",\n" + "                    \"version\": \"NEW\"\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5729992\",\n" + "                \"applyTime\": 1692065044000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，您提交的线索，微信平台已处罚，符合奖励标准，请点击链接：https://dx5.cn/4i65LQ 注册账号，奖励将通过德高好工匠平台进行发放，感谢参与。如有疑问请拨打4008009889咨询。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"假货举报内容回复\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                },\n" + "                \"shortUrlInfo\": {\n" + "                    \"sid\": \"4i65LQ\",\n" + "                    \"version\": \"NEW\"\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5730588\",\n" + "                \"applyTime\": 1692063057000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，您提交的线索符合举报要求，请耐心等待调查结果，感谢参与。如有疑问请拨打4008009889咨询。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"假货举报回复请等待短信\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5729968\",\n" + "                \"applyTime\": 1692062686000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，您提交的线索是重复线索，不符合举报填写要求，感谢参与。如有疑问请拨打4008009889咨询。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"假货举报内容回复\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5729964\",\n" + "                \"applyTime\": 1692000063000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，已收到您提交的线索，本公司将对线索进行分析和查重，五个工作日内回复审查结果，感谢参与。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": true,\n" + "                \"applyDescription\": \"假货举报内容回复\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                },\n" + "                \"webStatus\": 0,\n" + "                \"preOnlineDate\": 1692028800000\n" + "            },\n" + "            {\n" + "                \"id\": \"5729966\",\n" + "                \"applyTime\": 1692000089000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，您提交的线索不符合举报要求，感谢参与。如有疑问请拨打4008009889咨询。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"假货举报内容回复\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5729970\",\n" + "                \"applyTime\": 1692000138000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，您提交的线索，经本公司现场调查或相关国家机关执法现场无发现制售假货行为，不满足奖励标准，感谢参与。如有疑问请拨打4008009889咨询。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"假货举报内容回复\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5729988\",\n" + "                \"applyTime\": 1692000156000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，您提交的线索，微信平台不予处罚，不满足奖励标准，感谢参与。如有疑问请拨打4008009889咨询。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"假货举报内容回复\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5729998\",\n" + "                \"applyTime\": 1692000232000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者，您提交的线索，本公司正在调查核实中，请耐心等待结果，感谢参与。如有疑问请拨打4008009889咨询。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"假货举报内容回复\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5727758\",\n" + "                \"applyTime\": 1691981077000,\n" + "                \"tplType\": 1,\n" + "                \"content\": \"【西卡德高】您本次的验证码为#code#，请于10分钟内输入。如非本人操作，请忽略此信息。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"website\": \"DAVCO 德高\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": true,\n" + "                \"usedInWebsite\": false,\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                },\n" + "                \"webStatus\": 1,\n" + "                \"preOnlineDate\": 1692028800000\n" + "            },\n" + "            {\n" + "                \"id\": \"5729074\",\n" + "                \"applyTime\": 1691981223000,\n" + "                \"tplType\": 1,\n" + "                \"content\": \"【西卡德高】你好，线索举报兑换码为#doc_id#\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"website\": \"DAVCO 德高\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": true,\n" + "                \"usedInWebsite\": false,\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                },\n" + "                \"webStatus\": 1\n" + "            },\n" + "            {\n" + "                \"id\": \"5728976\",\n" + "                \"applyTime\": 1691979273000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】你好，线索举报工单号为#doc_id#\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"用于员工查询工单号，发送至手机\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5704978\",\n" + "                \"applyTime\": 1690269455000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！您可通过以下授权的线上商城购买德高产品：天猫：德高旗舰店；京东：德高官方旗舰店、德高京东自营旗舰店；拼多多：DAVCO德高旗舰店；抖音：德高官方旗舰店\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"客户主动查询产品购买渠道\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5704980\",\n" + "                \"applyTime\": 1690269488000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！您可通过以下授权的线上商城购买西卡产品：天猫：西卡旗舰店；京东：西卡官方旗舰店 \",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"客户主动查询产品购买渠道\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5674310\",\n" + "                \"applyTime\": 1688042544000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！因人工服务繁忙，十分抱歉未能及时响应。为了更好地为您提供服务，请点击以下链接在线填写咨询内容，我们将在1个工作日内安排工作人员为您服务。https://ccc.davco.cn/m/com-davco/newwf#/\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"在线客服发送短信，另外一个链接地址\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5674284\",\n" + "                \"applyTime\": 1688038696000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！因人工服务繁忙，十分抱歉未能及时响应。为了更好地为您提供服务，请点击以下链接在线填写咨询内容，我们将在1个工作日内安排工作人员为您服务https://ccc.davco.cn/m/com-davco/wfmain#/\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"在线客服发送短信，填写工单\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5669196\",\n" + "                \"applyTime\": 1687798379000,\n" + "                \"tplType\": 1,\n" + "                \"content\": \"【西卡德高】尊敬的来宾，您好。欢迎莅临2023西卡家装节。会务组已为您安排接机服务，请留意您的短信。如自驾前往的嘉宾，酒店提供免费停车服务，报“西卡公司”即可。会议酒店：上海佘山世茂洲际酒店。会议着装提醒：正式着装，建议非休闲着装。期待您的到来！\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"website\": \"https://ccc.davco.cn/\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": true,\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                },\n" + "                \"webStatus\": 0,\n" + "                \"preOnlineDate\": 1690732800000\n" + "            },\n" + "            {\n" + "                \"id\": \"5614946\",\n" + "                \"applyTime\": 1682393072000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】扫码领红包相关问题，可通过微信小程序搜索“德高好工匠”—点击“金币商城”—右上角点击客服进行咨询，或直接在微信添加客服微信号15221679177。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"关于扫码红包的问题，指引客户联系德高客服进行处理\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5613086\",\n" + "                \"applyTime\": 1682230053000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好，负责#belong_city##belong_district#的西卡德高销售人员联系方式为#customer_phone#，如有购买需求或合作意向敬请联系。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"向客户发送负责省市区销售人员的联系电话\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5457520\",\n" + "                \"applyTime\": 1673407950000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！查询德高产品真伪请点击以下链接https://tts.davco.cn/TTSDavco/Portal/ClientSearch/new/SecuritySearch.htm 具体操作：刮开产品外包装红色防伪标签上的银色涂层，在页面输入防伪码。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"发送德高产品真伪查询\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5457516\",\n" + "                \"applyTime\": 1673407839000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！查询西卡产品真伪请点击以下链接https://tts.davco.cn/TTSDavco/Portal/ClientSearch/new/xkSecuritySearch.htm 具体操作：刮开产品外包装防伪标签上的银色涂层，请点击按钮扫描被图层遮挡的二维码，或手动输入产品防伪码。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"发送防伪查询链接给客户，以便客户自助查询产品真伪\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5443536\",\n" + "                \"applyTime\": 1672046550000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！为了更好地为您提供服务，您反馈的技术问题请联系西卡德高技术人员：#name#咨询。如有任何疑问请致电4008009889，我们将竭诚为您服务。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"客户打电话进行技术咨询，向客户发送技术员姓名及电话\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5442100\",\n" + "                \"applyTime\": 1671791835000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！请点击以下链接提交假货举报的相关信息https://ccc.davco.cn/m/com-davco/fakerpt/ ，感谢您的反馈，谢谢！\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"客户来电举报购买到德高的假冒伪劣产品进行举报，发送此短信给客户点击链接填写假货具体信息\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5440812\",\n" + "                \"applyTime\": 1671618846000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！为了更好地为您提供服务，请点击以下链接在线填写咨询内容，我们将在1个工作日内安排专属客服为您服务。https://ccc.davco.cn/m/com-davco/newwf#/ \",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"提交工单\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5440804\",\n" + "                \"applyTime\": 1671618661000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者您好，异常反馈需提交防伪标签、生产日期和批号、产品正反面照片，请提前拍摄以供上传。防伪查询异常反馈请点击https://ccc.davco.cn/m/com-davco/antifake1/ ，提交相关信息\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"防伪查询异常反馈\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5440808\",\n" + "                \"applyTime\": 1671618738000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者您好，无标签产品查询需提交生产日期和批号、产品正反面照片，请提前拍摄以供上传。无标签产品查询请点击https://ccc.davco.cn/m/com-davco/antifake2/ ，提交相关信息\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"无标签防伪查询异常反馈\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5438084\",\n" + "                \"applyTime\": 1671275549000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！您所查询的专卖店地址：#address#，联系电话：#phone#。您可点击以下链接查询更多专卖店的信息 http://stores.davco.cn/\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"发送官网门店地址联系方式。\\n#address#官网门店地址\\n#phone#官网门店电话\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5418458\",\n" + "                \"applyTime\": 1669871701000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者您好，您于#date#提交的#workorderno#异常反馈已处理完毕，查看结果请点击#url# 。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"客户反馈异常问题处理结果的通知\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5417520\",\n" + "                \"applyTime\": 1669793471000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者您好，异常反馈需提交防伪标签、生产日期和批号、产品正反面照片，请提前拍摄以供上传。防伪查询异常反馈请点击https://ccctest.davco.cn/m/com-davcodev/antifake1/ ，提交相关信息\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"西卡德高防伪查询异常反馈\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5417526\",\n" + "                \"applyTime\": 1669793452000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的消费者您好，无标签产品查询需提交生产日期和批号、产品正反面照片，请提前拍摄以供上传。无标签产品查询请点击https://ccctest.davco.cn/m/com-davcodev/antifake2/ ，提交相关信息\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"西卡德高无标签产品防伪查询异常反馈\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5417534\",\n" + "                \"applyTime\": 1669787999000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！为了更好地为您提供服务，请点击以下链接在线填写咨询内容，我们将在1个工作日内安排专属客服为您服务。https://ccctest.davco.cn/m/com-davcodev/newwf#/\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"非工作日短信自助留言\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5417528\",\n" + "                \"applyTime\": 1669778282000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户：查询德高授权专卖店地址及电话，请您登录德高官网http://stores.davco.cn/ 或微信关注公众号“德高”-点击右下角“实用助手”-“门店查询”。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"西卡德高门店信息查询\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5417532\",\n" + "                \"applyTime\": 1669778394000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户：您可以到德高专卖店购买西卡产品。查询德高授权专卖店地址及电话，请您登录德高官网http://stores.davco.cn/ 或微信关注公众号“德高”-点击右下角“实用助手”-“门店查询”。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"西卡德高门店信息查询\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5412006\",\n" + "                \"applyTime\": 1669172964000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】您有一个工单待处理。工单号：#doc_id#。请于企业微信，处理工单\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"通知及时处理公司内部工单。#doc_id#仅展示工单号。\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5410284\",\n" + "                \"applyTime\": 1669012218000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好！您于#date#反馈的问题现已处理完毕，您的感受对我们非常重要，诚邀您对本次售后服务进行评价( #url# )，感谢您的支持！如有任何疑问请致电4008009889，我们将竭诚为您服务。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"邀请客户进行投诉处理满意度调查\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5402694\",\n" + "                \"applyTime\": 1668138576000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户，您好，负责#belong_city#市#belong_district#区/县的西卡德高销售人员联系方式为#customer_phone#，如有购买需求或合作意向敬请联系。\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"将销售人员联系方式发送给客户，用于购买需求或合作意向的联系沟通。\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            },\n" + "            {\n" + "                \"id\": \"5400262\",\n" + "                \"applyTime\": 1667961717000,\n" + "                \"tplType\": 0,\n" + "                \"content\": \"【西卡德高】尊敬的客户：预约专卖店施工服务，请您在微信小程序上搜索“小德微装”下单，我们会在48小时内与您联系。\\n\",\n" + "                \"sign\": \"【西卡德高】\",\n" + "                \"checkStatus\": 0,\n" + "                \"subAccountId\": \"890000000021127778\",\n" + "                \"usedInAPP\": false,\n" + "                \"usedInWeixin\": false,\n" + "                \"usedInWebsite\": false,\n" + "                \"applyDescription\": \"预约施工服务，操作指引\",\n" + "                \"user\": {\n" + "                    \"nick\": \"客服系统\",\n" + "                    \"isMarketAccount\": false,\n" + "                    \"apiKey\": \"5877****4096\",\n" + "                    \"isAutoAddUnsubscribeTip\": false\n" + "                }\n" + "            }\n" + "        ],\n" + "        \"pagin\": {\n" + "            \"pageNo\": 1,\n" + "            \"pageSize\": 100,\n" + "            \"totalCount\": 44,\n" + "            \"pageCount\": 1\n" + "        }\n" + "    },\n" + "    \"success\": true,\n" + "    \"succ\": true\n" + "}";

        // 获取模板信息
        JSONObject sms_tpJson = JSONObject.fromObject(inData);
        log.debug("获取模板信息:" + sms_tpJson.toString());

        // 获取模板数组
        JSONArray sms_tpArr = sms_tpJson.getJSONObject("data").getJSONArray("records");
        log.debug("获取模板数组:" + sms_tpJson.toString());


        StringBuffer para_sqls = new StringBuffer();
        for (int i = 0; i < sms_tpArr.size(); i++) {
            log.debug("获取模板数组:" + sms_tpArr.getJSONObject(i));

            String id = KHUtil.GetSFJV(sms_tpArr.getJSONObject(i), "id");
            String applyTime = KHUtil.GetSFJV(sms_tpArr.getJSONObject(i), "applyTime");
            String tplType = KHUtil.GetSFJV(sms_tpArr.getJSONObject(i), "tplType");
            String content = KHUtil.GetSFJV(sms_tpArr.getJSONObject(i), "content");
            String sign = KHUtil.GetSFJV(sms_tpArr.getJSONObject(i), "sign");
            String checkStatus = KHUtil.GetSFJV(sms_tpArr.getJSONObject(i), "checkStatus");
            String subAccountId = KHUtil.GetSFJV(sms_tpArr.getJSONObject(i), "subAccountId");


            String SQL = "Replace Into Dg_Sms_Template (Id, Applytime, Tpltype, Content, Sign, Checkstatus, Subaccountid, Sync_Time) Values ('" + id + "', '" + applyTime + "', '" + tplType + "', '" + content + "', '" + sign + "', '" + checkStatus + "', '" + subAccountId + "', Now());";

            para_sqls.append(SQL).append(System.lineSeparator());
        }

        System.out.println(para_sqls);

        KHFileUtil.writeFile(para_sqls.toString(), "E:\\Dg_Sms_Template_" + KHUtil.getRandomString(6) + ".sql");

    }
}
